package org.springcloud.wisdom.springcloud_03_freshman.student.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springcloud.wisdom.springcloud_03_freshman.student.entity.Goods;

import java.util.List;

@Mapper
public interface GoodsDao {
    //根据sid查物品记录
    @Select("select * from goods where sid =#{sid}")
    public List<Goods> getGoodsBySid(String sid);

    //根据sid更新物品记录
    @Update("update goods set receiveStatus=#{receiveStatus},receiveDt=#{receiveDt} where sid=#{sid}")
    public  int UpdateGoodsBySid(Goods goods);
}
